UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pKPF8hBpvCtXwPQppGHIwk1RqI8aK6gyPi8/oIvvIA4='
WHERE
key_id = 'b57baf62d0ec5a30fa40c85a58bbc9d41c2356d2df9a1dd1859a1f3617f7273a'
AND (
token = 'pKPF8hBpvCtXwPQppGHIwk1RqI8aK6gyPi8/oIvvIA4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)