UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aQasmXKrS/9owd9L1BkT4k1IkJpa2YnaaTmIznneGT0='
WHERE
key_id = '5caf57bd428828b41359d9e330cf194172f82fae69cf39945e599e264b009f1a'
AND (
token = 'aQasmXKrS/9owd9L1BkT4k1IkJpa2YnaaTmIznneGT0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)