UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mCayTepqcqkc4H3yFK/aYMNCJPH/INkOk8IUBsOzwNc='
WHERE
key_id = '78cc98850ca24de0e35e1819a71af9c2d1587aa930a6497b1dda0fdd306546c4'
AND (
token = 'mCayTepqcqkc4H3yFK/aYMNCJPH/INkOk8IUBsOzwNc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)