UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vX9RtaHCsnS23+g2nBPJkX/rAJHuEHM1QT/FDmEcLSI='
WHERE
key_id = 'f2f7d7c6d6add64d9a4bf32201155b4836e72743339102383b1e86a210198550'
AND (
token = 'vX9RtaHCsnS23+g2nBPJkX/rAJHuEHM1QT/FDmEcLSI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)