UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hC7APSDJfu/ZWzedgjI7AZaHIt25DayPF8m8CBnjg34='
WHERE
key_id = '9c0188bd7f658ff235a0204388aafb9fb2ace7b07c0ea83866c9ead1172537ba'
AND (
token = 'hC7APSDJfu/ZWzedgjI7AZaHIt25DayPF8m8CBnjg34='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)