UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XQVZg4600xPuc/3Nf8A90ZFvy2+HDLhsbJ+NW3OtzhY='
WHERE
key_id = 'b0048a1bcd76e4f4a2b10af6b2710551b365798ef5742f11ff874c8d6a831498'
AND (
token = 'XQVZg4600xPuc/3Nf8A90ZFvy2+HDLhsbJ+NW3OtzhY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)