UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pbXX5DH48AduX6QaHs48iv08THdUcl15cvVjX83GvKY='
WHERE
key_id = '683e7aead1dde0346fc53f3d7d21939e71c65136569fd7681bb440b116ec04ce'
AND (
token = 'pbXX5DH48AduX6QaHs48iv08THdUcl15cvVjX83GvKY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)