UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qwTKTuyF2Qy0gfXnUpSmXNlrAe4xLuDopwEpxd8Qa5A='
WHERE
key_id = '9f49e4e183487096b2e6f56cb83b639d86469d616ecdb6ba272c8a77a81e8b9a'
AND (
token = 'qwTKTuyF2Qy0gfXnUpSmXNlrAe4xLuDopwEpxd8Qa5A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)