UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r+4OtgcI5P+CS8lnrIx004CU1Tls9lP9qtvCmQN8pQs='
WHERE
key_id = '0365609da53a0076d617ac46c75d034c8f75a12f55be32bce3cb7146ccc8ac78'
AND (
token = 'r+4OtgcI5P+CS8lnrIx004CU1Tls9lP9qtvCmQN8pQs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)