UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QOEcGWKZw6xeJFilfTdVIN5DmpkRw0/rkUXfwYrUxgo='
WHERE
key_id = 'a8d4c98107376c29a006acf169b7cea92799a56e0fc23321366d622c20e69c0f'
AND (
token = 'QOEcGWKZw6xeJFilfTdVIN5DmpkRw0/rkUXfwYrUxgo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)