UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'XxhP4Au4UQFZN0hsGMpxBMxv/TGq/4yensiN9d0zQfE=' 
WHERE 
  key_id = '146cf4b799e34f4e315d44ecc9b0b1b717908980712024efe6877c18d1da879e' 
  AND (
    token = 'XxhP4Au4UQFZN0hsGMpxBMxv/TGq/4yensiN9d0zQfE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00104