UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vF1HuQNY6S9xIFWZBFHejT9VlavEFvEkfAjGWaZdxBs='
WHERE
key_id = '0c7c57f702ac3cf8dc8d18510b0bb363a3374281e8ea70812bdbf8c0eacfe4f5'
AND (
token = 'vF1HuQNY6S9xIFWZBFHejT9VlavEFvEkfAjGWaZdxBs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)