UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aPWhwVx3+Z2OOSWYVxAsBl1Mqwf99zaD8QauXeWK3q0='
WHERE
key_id = '7b0bb27bb4bf534975e915ca615ea70522dda9a06da22a61cf7f1a179eb0a487'
AND (
token = 'aPWhwVx3+Z2OOSWYVxAsBl1Mqwf99zaD8QauXeWK3q0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)