UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W4l31rSvJpVYSC6ErrnsOCh/x6lP9oOMriGfdNQiOYs='
WHERE
key_id = 'd7228f56ebd8f5b59912279b4b3dcf5c43acb13d5de51be2138634cc54af6aba'
AND (
token = 'W4l31rSvJpVYSC6ErrnsOCh/x6lP9oOMriGfdNQiOYs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)