UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'atcVG77scOQvDE8Yt0TUs2gWWj+AfyrTXY42ZDExGUU='
WHERE
key_id = 'c31bfa3a8235c086dec0d4a0859fc5c98a5a814009dfe61d26511fdd57aba76a'
AND (
token = 'atcVG77scOQvDE8Yt0TUs2gWWj+AfyrTXY42ZDExGUU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)