UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BXbVJLA8cWbd4vI6wRIQA/Q4+WZbV22wi35eLOtdJ6s='
WHERE
key_id = '15b71401c4cc48ce355e322e5ad680235d8b98de432dd1e945fc3643634a72a0'
AND (
token = 'BXbVJLA8cWbd4vI6wRIQA/Q4+WZbV22wi35eLOtdJ6s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)