UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zN549J3HOySmjhXJbR/3BzaoRAzLNKjJGijTitsk1fY='
WHERE
key_id = 'b0f21cfdd6f5d149def361956e7f9bc427e1335f2132443b5d01e3f297b3ebb6'
AND (
token = 'zN549J3HOySmjhXJbR/3BzaoRAzLNKjJGijTitsk1fY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)