UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JqbJX9azq+2qU/m9vdEWjS7E/vN+Huj7qEAFaEyyWAQ='
WHERE
key_id = 'cd27e39d88d05239a07ba0404cd0730ce0f7d8137d41284336f648f5fadc8896'
AND (
token = 'JqbJX9azq+2qU/m9vdEWjS7E/vN+Huj7qEAFaEyyWAQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)