UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dmhl++4MrY4HxUr767v8ELchzWeWJiGUSoQYoW10saU='
WHERE
key_id = '3870459a0c91a54a3056282988bacecb3152f08f5e48dedf4cd6578fd885f065'
AND (
token = 'dmhl++4MrY4HxUr767v8ELchzWeWJiGUSoQYoW10saU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)