UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZaUxZvdd14i2CSC/QT8wSIuJZke276WSwuLa4DUDYho='
WHERE
key_id = 'a5b88566759a94890dc58c27914667bb1c0ee844cfb2ad4f4af093fccb55f5b6'
AND (
token = 'ZaUxZvdd14i2CSC/QT8wSIuJZke276WSwuLa4DUDYho='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)