UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6zUO6S2jmZuDvqZeY5Bp6wP8zhBKjzDCx28MbU124Bs='
WHERE
key_id = 'd03d48a1ab603e9b7274a1155912fd6d0954111eee02a32e0d73be844fe73537'
AND (
token = '6zUO6S2jmZuDvqZeY5Bp6wP8zhBKjzDCx28MbU124Bs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)