UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3pCh42P94NU2rwUj55UC3BRVjWzw3w+GUuMbNh7evvU='
WHERE
key_id = 'd40a641ea3df5d333cf66e0192de4f10a2c1d3e76c552e5af8ab2ecddcdc6ad8'
AND (
token = '3pCh42P94NU2rwUj55UC3BRVjWzw3w+GUuMbNh7evvU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)