UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6A29nhzdCQfoF4jwogmn1ngwIVFaNAAtnwbebiRG14s='
WHERE
key_id = '2dcfa5a928351f88370a4b173636fca6e85932017f57f1172e1808859bbdcd02'
AND (
token = '6A29nhzdCQfoF4jwogmn1ngwIVFaNAAtnwbebiRG14s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)