UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ubRiK5U7z73P5tOZ0PcfT1y1Qy34cntyQjspiKCdAQQ='
WHERE
key_id = 'f97ec1ce0ff55452ac88554b477cbee771d2a3a5e0f557c94f17688ddf297fc7'
AND (
token = 'ubRiK5U7z73P5tOZ0PcfT1y1Qy34cntyQjspiKCdAQQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)