UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p6rT7GUgWF0yqG0p75Fk9PCxJeU87cglujsCUS/Hg34='
WHERE
key_id = 'b079f88d94511ed8737ed1f3b50a0e3cee1c6c6b0bef50acd7417e8d26d300dd'
AND (
token = 'p6rT7GUgWF0yqG0p75Fk9PCxJeU87cglujsCUS/Hg34='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)