UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mjl22NZnLI3If++bXwsm/DmmRRhyeIi+1mhM2bw6pU8='
WHERE
key_id = 'bc1cfdd6706bb1e4d06841f91e234f1477ee9d4ca0a69a798cf2a12d423da391'
AND (
token = 'mjl22NZnLI3If++bXwsm/DmmRRhyeIi+1mhM2bw6pU8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)