UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TSbdfcRAtvCItSLVgJG7aM2uW0addwcp5CYy5nvJUag='
WHERE
key_id = '420b1635febf00c483b2186df2ddb00686e11020d440fa677071104dacd872eb'
AND (
token = 'TSbdfcRAtvCItSLVgJG7aM2uW0addwcp5CYy5nvJUag='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)