UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9dFd9fgo5h0st3Zzj/nNvHViPDp59K1b7g4Ao0JgHAU='
WHERE
key_id = 'f53660b5ace5ff194f38eae568f9dd87fbd1d2c487f6033f0f77ce817753cb1c'
AND (
token = '9dFd9fgo5h0st3Zzj/nNvHViPDp59K1b7g4Ao0JgHAU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)