UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+otLPWcj1vWzysyguywhz1rdV2zYZYe/HS1/sQq9lM0='
WHERE
key_id = '0bd0d9f07c594e02d805c109b9cafb0835e712906837b07e09b9b41ff187d389'
AND (
token = '+otLPWcj1vWzysyguywhz1rdV2zYZYe/HS1/sQq9lM0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)