UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0LHmH0SAeDvyI9BJETAKiv1rgCLargj7pIC6u2j8chk='
WHERE
key_id = '42bfcc0b2e60a837005524e37e971fb719aa3c7eb2882b31ff1fa630b05fc619'
AND (
token = '0LHmH0SAeDvyI9BJETAKiv1rgCLargj7pIC6u2j8chk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)