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