UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vTwPPiv6HF16gGsJWb0mfXUw/lsZXYpwqm+xlv9AkxU='
WHERE
key_id = '4c45b194024d455cb901c434573999ea732eb8ba2728c846043e0970367962bd'
AND (
token = 'vTwPPiv6HF16gGsJWb0mfXUw/lsZXYpwqm+xlv9AkxU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)