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