UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AaE9Q8XeY6Bergs0PntI73X18MAH3dYV7JFrgE9hYJA='
WHERE
key_id = '179af81b9abc0ee239fd6ce0dfd8ddf5512fa9ba708ceee37b12920e2384542a'
AND (
token = 'AaE9Q8XeY6Bergs0PntI73X18MAH3dYV7JFrgE9hYJA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)